LOAD TABLE CONVENTIONAL
Short Description
The table is being inserted into via conventional methods i.e. NOT direct path
Detailed Description​
Rows are being loaded into a table via CONVENTIONAL methods. This is usually the result of an INSERT
statement.
If the insert is the result of a CREATE TABLE AS SELECT
(CTAS) you may see an additional step in the plan where optimizer stats are automatically gathered. (OPTIMIZER STATISTICS GATHERING
)
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.